package com.groupseven.happycampus.mapper;


import com.groupseven.happycampus.common.pojo.Seat;
import com.groupseven.happycampus.common.pojo.Student;
import com.groupseven.happycampus.common.vo.GradePie;
import com.groupseven.happycampus.common.vo.SelectRoomVo;
import com.groupseven.happycampus.common.vo.SexBar;
import com.groupseven.happycampus.common.vo.StudentStatusBarVo;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;


/**
 * @CreateTime: 2022-07-25 21:53
 * @author: bestzqw
 * @Description:  此接口用于操作所有关于图书馆座位预约占有操作
 */
public interface SubscribeMapper {


    List<Seat> seatList();

    int updateSeat(Seat seat);

    List<GradePie> selectByGradePie();

    List<SexBar> selectBySexBar();

    List<Student> studentListByroomId(Map<String,String> params);

    List<SelectRoomVo> groupByRoom();

    int addStudent(Student student);

    Seat searchSeat(@Param("roomId") String roomId);


    int updateStudentStatus(@Param("id") Integer id,@Param("status") Boolean status);

    List<StudentStatusBarVo> selectByStudentStatus();
}
